package com.beiben.trialproduce.part.domain;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import com.fasterxml.jackson.annotation.JsonFormat;
import java.math.BigDecimal;
import java.util.Date;

/**
 * 零件对象 trial_produce_part
 * 
 * @author 熊国强
 * @date 2020-11-25
 */
@HeadRowHeight(30)
@ContentRowHeight(40)
public class PartExcelVo
{
    private static final long serialVersionUID = 1L;

    /** 零件ID */
    @ExcelIgnore
    private Long partId;

    /*序号*/
    @ExcelProperty({"科研验证物资库存汇总表","序号"})
    @ColumnWidth(4)
    private String orderNum;

    /** 零部件号 */
    @ExcelProperty({"科研验证物资库存汇总表","零部件号(或材料编号或车号)"})
    @ColumnWidth(9)
    private String code;

    /** 零部件名称 */
    @ExcelProperty({"科研验证物资库存汇总表","零部件名称(或材料名称或整车型号)"})
    @ColumnWidth(9)
    private String name;

    /** 材料品号 */
    @ExcelProperty({"科研验证物资库存汇总表","材料品号"})
    @ColumnWidth(9)
    private String pinhao;

    /** 规格型号 */
    @ExcelProperty({"科研验证物资库存汇总表","规格型号"})
    @ColumnWidth(9)
    private String model;

    /** 计量单位 */
    @ExcelProperty({"科研验证物资库存汇总表","计量单位"})
    @ColumnWidth(4)
    private String unitName;

    /** 单价 */
    @ExcelProperty({"科研验证物资库存汇总表","单价"})
    @ColumnWidth(4)
    private BigDecimal price;

    /** 账面数量 */
    @ExcelProperty({"科研验证物资库存汇总表","账面数量"})
    @ColumnWidth(4)
    private Long partNum;

    /*正常存货*/
    @ExcelProperty({"科研验证物资库存汇总表","实际盘点数量","正常存货"})
    @ColumnWidth(4)
    private String normalStock;

    /*技术淘汰存货*/
    @ExcelProperty({"科研验证物资库存汇总表","实际盘点数量","非正常存货","技术淘汰存货","技术淘汰存货"})
    @ColumnWidth(4)
    private String weedOut;

    /*残损变质存货*/
    @ExcelProperty({"科研验证物资库存汇总表","实际盘点数量","非正常存货","残损变质存货","残损变质存货"})
    @ColumnWidth(4)
    private String badStock;

    /*积压呆滞存货*/
    @ExcelProperty({"科研验证物资库存汇总表","实际盘点数量","非正常存货","积压呆滞存货","积压呆滞存货"})
    @ColumnWidth(4)
    private String overStock;

    /*其他非正常性存货*/
    @ExcelProperty({"科研验证物资库存汇总表","实际盘点数量","非正常存货","其他非正常性存货","其他非正常性存货"})
    @ColumnWidth(4)
    private String otherUnNormalStock;

    /*非正常存货小计*/
    @ExcelProperty({"科研验证物资库存汇总表","实际盘点数量","小计"})
    @ColumnWidth(4)
    private String unNormalSubtotal;

    /*1年以内*/
    @ExcelProperty({"科研验证物资库存汇总表","实际盘点数量","存货库龄","1年以内","1年以内"})
    @ColumnWidth(4)
    private String oneYear;

    /*1-2年*/
    @ExcelProperty({"科研验证物资库存汇总表","实际盘点数量","存货库龄","1-2年","1-2年"})
    @ColumnWidth(4)
    private String oneTwoYear;

    /*2-3 年*/
    @ExcelProperty({"科研验证物资库存汇总表","实际盘点数量","存货库龄","2-3 年","2-3 年"})
    @ColumnWidth(4)
    private String twoThreeYear;

    /*3-5年*/
    @ExcelProperty({"科研验证物资库存汇总表","实际盘点数量","存货库龄","3-5年","3-5年"})
    @ColumnWidth(4)
    private String threeFiveYear;

    /*5年以上*/
    @ExcelProperty({"科研验证物资库存汇总表","实际盘点数量","存货库龄","5年以上","5年以上"})
    @ColumnWidth(4)
    private String fiveYear;

    /*存货库存小计*/
    @ExcelProperty({"科研验证物资库存汇总表","实际盘点数量","存货库龄","小计"})
    @ColumnWidth(4)
    private String stockYearSubtotal;

    /*盈亏*/
    @ExcelProperty({"科研验证物资库存汇总表","实际盘点数量","盈亏"})
    @ColumnWidth(4)
    private String profitAndLoss;

    /** 现存状态 */
    @ExcelProperty({"科研验证物资库存汇总表","现存状态"})
    @ColumnWidth(4)
    private String partState;

    /** 存放地点 */
    @ExcelProperty({"科研验证物资库存汇总表","存放地点"})
    @ColumnWidth(15)
    private String address;

    @ExcelProperty({"科研验证物资库存汇总表","备注"})
    @ColumnWidth(10)
    private String remark;

    /** 使用状态 */
    @ExcelProperty({"科研验证物资库存汇总表","使用状态"})
    @ColumnWidth(4)
    private String partUseState;

    /** 物资由来 */
    @ExcelProperty({"科研验证物资库存汇总表","物资由来"})
    @ColumnWidth(10)
    private String derive;

    /** 入库时间 */
    @JsonFormat(pattern = "yyyy-MM-dd")
    @DateTimeFormat("yyyy-MM-dd")
    @ExcelProperty({"科研验证物资库存汇总表","入库时间"})
    @ColumnWidth(10)
    private Date productionTime;

    /** 零件使用履历 */
    @ExcelProperty({"科研验证物资库存汇总表","零件使用履历"})
    @ColumnWidth(15)
    private String record;

    public void setPartId(Long partId) 
    {
        this.partId = partId;
    }

    public Long getPartId() 
    {
        return partId;
    }
    public void setCode(String code) 
    {
        this.code = code;
    }

    public String getCode() 
    {
        return code;
    }
    public void setName(String name) 
    {
        this.name = name;
    }

    public String getName() 
    {
        return name;
    }
    public void setPinhao(String pinhao) 
    {
        this.pinhao = pinhao;
    }

    public String getPinhao() 
    {
        return pinhao;
    }
    public void setModel(String model) 
    {
        this.model = model;
    }

    public String getModel() 
    {
        return model;
    }
    public void setUnitName(String unitName) 
    {
        this.unitName = unitName;
    }

    public String getUnitName() 
    {
        return unitName;
    }
    public void setPrice(BigDecimal price) 
    {
        this.price = price;
    }

    public BigDecimal getPrice() 
    {
        return price;
    }
    public void setPartNum(Long partNum) 
    {
        this.partNum = partNum;
    }

    public Long getPartNum() 
    {
        return partNum;
    }
    public void setPartState(String partState) 
    {
        this.partState = partState;
    }

    public String getPartState() 
    {
        return partState;
    }
    public void setPartUseState(String partUseState) 
    {
        this.partUseState = partUseState;
    }

    public String getPartUseState() 
    {
        return partUseState;
    }
    public void setAddress(String address) 
    {
        this.address = address;
    }

    public String getAddress() 
    {
        return address;
    }
    public void setDerive(String derive) 
    {
        this.derive = derive;
    }

    public String getDerive() 
    {
        return derive;
    }
    public void setProductionTime(Date productionTime) 
    {
        this.productionTime = productionTime;
    }

    public Date getProductionTime() 
    {
        return productionTime;
    }
    public void setRecord(String record) 
    {
        this.record = record;
    }

    public String getRecord() 
    {
        return record;
    }

    public String getRemark() {
        return remark;
    }

    public void setRemark(String remark) {
        this.remark = remark;
    }

    public String getOrderNum() {
        return orderNum;
    }

    public void setOrderNum(String orderNum) {
        this.orderNum = orderNum;
    }

    public String getNormalStock() {
        return normalStock;
    }

    public void setNormalStock(String normalStock) {
        this.normalStock = normalStock;
    }

    public String getWeedOut() {
        return weedOut;
    }

    public void setWeedOut(String weedOut) {
        this.weedOut = weedOut;
    }

    public String getBadStock() {
        return badStock;
    }

    public void setBadStock(String badStock) {
        this.badStock = badStock;
    }

    public String getOverStock() {
        return overStock;
    }

    public void setOverStock(String overStock) {
        this.overStock = overStock;
    }

    public String getOtherUnNormalStock() {
        return otherUnNormalStock;
    }

    public void setOtherUnNormalStock(String otherUnNormalStock) {
        this.otherUnNormalStock = otherUnNormalStock;
    }

    public String getUnNormalSubtotal() {
        return unNormalSubtotal;
    }

    public void setUnNormalSubtotal(String unNormalSubtotal) {
        this.unNormalSubtotal = unNormalSubtotal;
    }

    public String getOneYear() {
        return oneYear;
    }

    public void setOneYear(String oneYear) {
        this.oneYear = oneYear;
    }

    public String getOneTwoYear() {
        return oneTwoYear;
    }

    public void setOneTwoYear(String oneTwoYear) {
        this.oneTwoYear = oneTwoYear;
    }

    public String getTwoThreeYear() {
        return twoThreeYear;
    }

    public void setTwoThreeYear(String twoThreeYear) {
        this.twoThreeYear = twoThreeYear;
    }

    public String getThreeFiveYear() {
        return threeFiveYear;
    }

    public void setThreeFiveYear(String threeFiveYear) {
        this.threeFiveYear = threeFiveYear;
    }

    public String getFiveYear() {
        return fiveYear;
    }

    public void setFiveYear(String fiveYear) {
        this.fiveYear = fiveYear;
    }

    public String getStockYearSubtotal() {
        return stockYearSubtotal;
    }

    public void setStockYearSubtotal(String stockYearSubtotal) {
        this.stockYearSubtotal = stockYearSubtotal;
    }

    public String getProfitAndLoss() {
        return profitAndLoss;
    }

    public void setProfitAndLoss(String profitAndLoss) {
        this.profitAndLoss = profitAndLoss;
    }
}
